/*
 Navicat Premium Data Transfer

 Source Server         : revervation
 Source Server Type    : MySQL
 Source Server Version : 80200 (8.2.0)
 Source Host           : localhost:3306
 Source Schema         : school

 Target Server Type    : MySQL
 Target Server Version : 80200 (8.2.0)
 File Encoding         : 65001

 Date: 17/04/2024 10:38:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `no` int DEFAULT NULL,
  `is_show` varchar(255) DEFAULT NULL,
  `parent_id` int DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `component` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单';

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` (`id`, `name`, `code`, `no`, `is_show`, `parent_id`, `icon`, `path`, `component`) VALUES (1, '信息管理', 'infoManage', 2, '1', 0, 'el-icon-info', '/infoManage', NULL);
INSERT INTO `menu` (`id`, `name`, `code`, `no`, `is_show`, `parent_id`, `icon`, `path`, `component`) VALUES (2, '首页', 'index', 1, '1', 0, 'el-icon-index', NULL, 'Home');
INSERT INTO `menu` (`id`, `name`, `code`, `no`, `is_show`, `parent_id`, `icon`, `path`, `component`) VALUES (3, '学生信息', 'stuInfo', 1, '1', 1, NULL, '/stuInfo', NULL);
INSERT INTO `menu` (`id`, `name`, `code`, `no`, `is_show`, `parent_id`, `icon`, `path`, `component`) VALUES (4, '老师信息', 'teInfo', 2, '1', 1, NULL, '/teInfo', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
